﻿CREATE PROCEDURE [branding].[GetTextById]
	@textId int
AS
	select	bt.ID,
			CAST('text' as varchar(10)) as ObjectType,
			bt.Tag,
			bt.SubTag,
			bt.ResourceId,
			bt.Brand,
			bt.ContentLength,
			bt.[Text]
	from	branding.[Text] as bt
	where	bt.ID = @textId;
RETURN 0